Data license: CC0 · Data source: metmuseum/openaccess
This data as json, CSV (advanced)
Suggested facets: Is Public Domain, Title, Artist Role, Artist Display Name, Artist Display Bio, Artist Alpha Sort, Artist Nationality, Artist Begin Date, Artist End Date, Object Date, Object Begin Date, Object End Date, Medium, Credit Line, Geography Type, City, Country
Link | rowid ▼ | Object Number | Is Highlight | Is Public Domain | Object ID | Department | Object Name | Title | Culture | Period | Dynasty | Reign | Portfolio | Artist Role | Artist Prefix | Artist Display Name | Artist Display Bio | Artist Suffix | Artist Alpha Sort | Artist Nationality | Artist Begin Date | Artist End Date | Object Date | Object Begin Date | Object End Date | Medium | Dimensions | Credit Line | Geography Type | City | State | County | Country | Region | Subregion | Locale | Locus | Excavation | River | Classification | Rights and Reproduction | Link Resource | Metadata Date | Repository |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
7644 | 7644 | 1974.356.42 | 0 | 0 | 8144 | American Decorative Arts 1 | Tall clock 886 | Tall Clock | American 1 | ca. 1815 | 1812 | 1815 | Walnut, beach, applewood or pearwood 1252 | 92 3/4 x 27 1/8 x 15 7/8 in. (235.6 x 68.9 x 40.3 cm) | The Lesley and Emma Sheafer Collection, Bequest of Emma A. Sheafer, 1973 | Made in 1 | United States 3 | Furniture 4 | http://www.metmuseum.org/art/collection/search/8144 | 4/23/2018 8:00:01 AM | Metropolitan Museum of Art, New York, NY 1 | |||||||||||||||||||||||
7645 | 7645 | 10.125.388 | 0 | 1 | 8145 | American Decorative Arts 1 | Tall clock 886 | Tall Clock | American 1 | Maker 1 | Benjamin Bagnall | 1689–1773 | Bagnall, Benjamin 1067 | 1689 | 1773 | 1725–40 | 1725 | 1740 | Walnut, white pine 393 | 87 x 20 5/8 x 11 3/8 in. (221 x 52.4 x 28.9 cm) | Gift of Mrs. Russell Sage, 1909 | Made in 1 | Boston 8 | United States 3 | Furniture 4 | http://www.metmuseum.org/art/collection/search/8145 | 4/23/2018 8:00:01 AM | Metropolitan Museum of Art, New York, NY 1 | ||||||||||||||||
7646 | 7646 | 18.110.63 | 0 | 1 | 8146 | American Decorative Arts 1 | Tall clock 886 | Tall Clock | American 1 | Maker 1 | Samuel Bagnall | active ca. 1740–1760 | Bagnall, Samuel 1068 | 1737 | 1760 | 1740–60 | 1740 | 1760 | Walnut 50 | 84 3/8 x 17 1/4 x 10 1/4 in. (214.3 x 43.8 x 26 cm) | John Stewart Kennedy Fund, 1918 | Made in 1 | Boston 8 | United States 3 | Furniture 4 | http://www.metmuseum.org/art/collection/search/8146 | 4/23/2018 8:00:01 AM | Metropolitan Museum of Art, New York, NY 1 | ||||||||||||||||
7647 | 7647 | 25.115.42 | 0 | 1 | 8147 | American Decorative Arts 1 | Tall clock 886 | Tall Clock | American 1 | Maker 1 | Gawen Brown | 1719–1801 | Brown, Gawen 1069 | 1719 | 1801 | 1750–60 | 1750 | 1760 | Mahogany, chestnut, white pine 1253 | 91 3/8 x 21 1/8 x 10 1/2 in. (232.1 x 53.7 x 26.7 cm) | Rogers Fund, 1925 | Made in 1 | Boston 8 | United States 3 | Furniture 4 | http://www.metmuseum.org/art/collection/search/8147 | 4/23/2018 8:00:01 AM | Metropolitan Museum of Art, New York, NY 1 | ||||||||||||||||
7648 | 7648 | 30.120.17 | 0 | 1 | 8148 | American Decorative Arts 1 | Tall clock 886 | Tall Clock | American 1 | Maker 1 | William Claggett | 1696–1749 | Claggett, William 1070 | 1696 | 1749 | 1740–50 | 1740 | 1750 | Mahogany, red maple, tulip poplar 1254 | 104 1/2 x 20 3/8 x 10 3/4 in. (265.4 x 51.8 x 27.3 cm) | The Sylmaris Collection, Gift of George Coe Graves, 1930 | Made in 1 | Newport 81 | United States 3 | Furniture 4 | http://www.metmuseum.org/art/collection/search/8148 | 4/23/2018 8:00:01 AM | Metropolitan Museum of Art, New York, NY 1 | ||||||||||||||||
7649 | 7649 | 1976.279 | 0 | 1 | 8149 | American Decorative Arts 1 | Tall clock 886 | Tall Clock | American 1 | Maker 1 | Jacob Diehl | 1776–1858 | Diehl, Jacob 1071 | 1776 | 1858 | ca. 1800 | 1797 | 1800 | Walnut, pine 639 | 96 1/2 x 21 1/2 x 12 1/2 in. (245.1 x 54.6 x 31.8 cm) | Purchase, Douglas and Priscilla de Forest Williams, Mr. and Mrs. Eric M. Wunsch and The Sack Foundation Gifts, 1976 | Made in 1 | Reading 190 | United States 3 | Furniture 4 | http://www.metmuseum.org/art/collection/search/8149 | 4/23/2018 8:00:01 AM | Metropolitan Museum of Art, New York, NY 1 | ||||||||||||||||
7650 | 7650 | 1980.458 | 0 | 1 | 8150 | American Decorative Arts 1 | Tall clock 886 | Tall Clock | American 1 | Maker 1 | Jacob Diehl | 1776–1858 | Diehl, Jacob 1071 | 1776 | 1858 | ca. 1800 | 1797 | 1800 | Mahogany, satinwood veneer with white pine, yellow poplar 651 | 104 x 19 1/2 in. (264.2 x 49.5 cm) | Friends of the American Wing Fund, 1980 | Made in 1 | Reading 190 | United States 3 | Furniture 4 | http://www.metmuseum.org/art/collection/search/8150 | 4/23/2018 8:00:01 AM | Metropolitan Museum of Art, New York, NY 1 | ||||||||||||||||
7651 | 7651 | 43.88 | 0 | 1 | 8151 | American Decorative Arts 1 | Tall clock 886 | Tall clock | American 1 | Maker 1 | James Dinsmore | active ca. 1803–1823 | Dinsmore, James 1072 | 1800 | 1823 | 1803–9 | 1803 | 1809 | Cherry, mahogany with maple, white pine, yellow poplar 1255 | 91 1/4 x 20 5/8 in. (231.8 x 52.4 cm) | Rogers Fund, 1943 | Made in 1 | Hopkinton 263 | United States 3 | Furniture 4 | http://www.metmuseum.org/art/collection/search/8151 | 4/23/2018 8:00:01 AM | Metropolitan Museum of Art, New York, NY 1 | ||||||||||||||||
7652 | 7652 | 43.148 | 0 | 1 | 8152 | American Decorative Arts 1 | Tall clock 886 | Tall Clock | American 1 | Maker 1 | Isaac Doolittle | 1721–1800 | Doolittle, Isaac 1073 | 1721 | 1800 | 1765 | 1765 | 1765 | Cherry 71 | 91 1/2 x 19 1/2 in. (232.4 x 49.5 cm) | Bequest of Helena D. Swift, 1943 | Made in 1 | New Haven 114 | United States 3 | Furniture 4 | http://www.metmuseum.org/art/collection/search/8152 | 4/23/2018 8:00:01 AM | Metropolitan Museum of Art, New York, NY 1 | ||||||||||||||||
7653 | 7653 | 1981.160.1 | 0 | 1 | 8153 | American Decorative Arts 1 | Tall clock 886 | Tall Clock | American 1 | Maker 1 | Jonathan Mulliken | Mulliken, Jonathan 337 | 9999 | ca. 1780–92 | 1777 | 1792 | Cherry, white pine 499 | 85 x 23 1/4 x 11 1/8 in. (215.9 x 59.1 x 28.3 cm) | Gift of Alexander Acevedo, 1981 | Possibly made in|Possibly made in 3 | Goffstown|Bedford 264 | United States|United States 8 | Furniture 4 | http://www.metmuseum.org/art/collection/search/8153 | 4/23/2018 8:00:01 AM | Metropolitan Museum of Art, New York, NY 1 | ||||||||||||||||||
7654 | 7654 | 30.120.62 | 0 | 1 | 8154 | American Decorative Arts 1 | Tall clock 886 | Tall Clock | American 1 | Maker 1 | Attributed to | Matthew Egerton Jr. | active ca. 1785–1837 | Egerton, Jr. Matthew 1074 | 1782 | 1837 | 1810–15 | 1810 | 1815 | Mahogany, satinwood, tulip poplar, white pine 1256 | 90 x 19 x 10 1/4 in. (228.6 x 48.3 x 26 cm) | The Sylmaris Collection, Gift of George Coe Graves, 1930 | Made in 1 | New Brunswick 265 | United States 3 | Furniture 4 | http://www.metmuseum.org/art/collection/search/8154 | 4/23/2018 8:00:01 AM | Metropolitan Museum of Art, New York, NY 1 | |||||||||||||||
7655 | 7655 | 18.110.29 | 0 | 1 | 8155 | American Decorative Arts 1 | Tall clock 886 | Tall Clock | American 1 | Maker 1 | Thomas Harland | 1735–1807 | Harland, Thomas 1075 | 1735 | 1807 | ca. 1775 | 1772 | 1775 | Mahogany, white pine 179 | 93 3/4 x 21 1/8 x 10 1/2 in. (238.1 x 53.7 x 26.7 cm) | John Stewart Kennedy Fund, 1918 | Made in 1 | Norwich 5 | United States 3 | Furniture 4 | http://www.metmuseum.org/art/collection/search/8155 | 4/23/2018 8:00:01 AM | Metropolitan Museum of Art, New York, NY 1 | ||||||||||||||||
7656 | 7656 | 47.103.3a–c | 0 | 1 | 8156 | American Decorative Arts 1 | Tall clock 886 | Tall Clock | American 1 | Maker 1 | Henry Hill | active ca. 1730–60 | Hill, Henry 1076 | 1727 | 1760 | 1730–50 | 1730 | 1750 | Walnut, tulip poplar 391 | 82 1/2 x 19 3/8 x 9 7/8 in. (209.6 x 49.2 x 25.1 cm) | Gift of Mrs. J. Insley Blair, 1947 | Made in 1 | New York 3 | United States 3 | Furniture 4 | http://www.metmuseum.org/art/collection/search/8156 | 4/23/2018 8:00:01 AM | Metropolitan Museum of Art, New York, NY 1 | ||||||||||||||||
7657 | 7657 | 32.55.8 | 0 | 1 | 8157 | American Decorative Arts 1 | Tall clock 886 | Tall Clock | American 1 | Maker 1 | Joakim Hill | 1783–1869 | Hill, Joakim 1077 | 1783 | 1869 | 1805–15 | 1805 | 1815 | Mahogany, maple, cherry, tulip poplar, white pine 1257 | 105 1/2 x 19 3/8 x 10 in. (268 x 49.2 x 25.4 cm) | The Sylmaris Collection, Gift of George Coe Graves, 1931 | Made in 1 | Flemington 266 | United States 3 | Furniture 4 | http://www.metmuseum.org/art/collection/search/8157 | 4/23/2018 8:00:01 AM | Metropolitan Museum of Art, New York, NY 1 | ||||||||||||||||
7658 | 7658 | 48.99 | 0 | 1 | 8158 | American Decorative Arts 1 | Tall clock 886 | Tall Clock | American 1 | Maker 1 | William Huston | ca. 1730–1791 | Huston, William 1078 | 1730 | 1791 | 1767–71 | 1767 | 1771 | Mahogany, poplar, cherry 1258 | 105 x 22 x 11 3/4 in. (266.7 x 55.9 x 29.8 cm) | Morris K. Jesup Fund, 1948 | Made in 1 | Philadelphia 1 | United States 3 | Furniture 4 | http://www.metmuseum.org/art/collection/search/8158 | 4/23/2018 8:00:01 AM | Metropolitan Museum of Art, New York, NY 1 | ||||||||||||||||
7659 | 7659 | 1986.82 | 0 | 1 | 8159 | American Decorative Arts 1 | Tall clock 886 | Tall Clock | American 1 | Maker 1 | Joseph Mulliken | active 1775–1800 | Mulliken, Joseph 1079 | 1775 | 1800 | ca. 1790 | 1787 | 1790 | Mahogany, white pine 179 | 95 x 19 3/4 x 10in. (241.3 x 50.2 x 25.4cm) | Bequest of Olive B. Floyd, in memory of Alice Downing Hart Floyd and Mary Jane Murray Farnsworth, 1985 | Made in 1 | Concord 30 | United States 3 | Furniture 4 | http://www.metmuseum.org/art/collection/search/8159 | 4/23/2018 8:00:01 AM | Metropolitan Museum of Art, New York, NY 1 | ||||||||||||||||
7660 | 7660 | 1985.261a–e | 0 | 1 | 8160 | American Decorative Arts 1 | Tall clock 886 | Tall Clock | American 1 | Maker 1 | Charles Rohlfs | American, Brooklyn, New York 1853–1936 Buffalo, New York | Rohlfs, Charles 237 | American 1 | 1853 | 1936 | ca. 1900 | 1897 | 1900 | Oak, copper 1259 | 81 x 19 1/8 x 9 in. (205.7 x 48.6 x 22.9 cm) | Gift of Roland Rohlfs, 1985 | Made in 1 | Buffalo 143 | United States 3 | Furniture 4 | http://www.metmuseum.org/art/collection/search/8160 | 4/23/2018 8:00:01 AM | Metropolitan Museum of Art, New York, NY 1 | |||||||||||||||
7661 | 7661 | 21.67 | 0 | 1 | 8161 | American Decorative Arts 1 | Tall clock 886 | Tall Clock | American 1 | Maker 1 | Nathan Storrs | 1768–1839 | Storrs, Nathan 1080 | 1768 | 1839 | 1800–1810 | 1800 | 1810 | Maple, holly, ebony, white pine, tulip poplar 1260 | H. 99 1/2 in. (252.7 cm) | Rogers Fund, 1921 | Made in 1 | Utica 267 | United States 3 | Furniture 4 | http://www.metmuseum.org/art/collection/search/8161 | 4/23/2018 8:00:01 AM | Metropolitan Museum of Art, New York, NY 1 | ||||||||||||||||
7662 | 7662 | 06.1206 | 0 | 1 | 8162 | American Decorative Arts 1 | Tall clock 886 | Tall Clock | American 1 | Maker 1 | Tiffany & Co. | 1837–present | Tiffany & Co. 193 | 1837 | 9999 | ca. 1882–85 | 1879 | 1885 | Mahogany, brass, metal 1261 | 105 x 23 1/2 x 13 in. (266.7 x 59.7 x 33 cm) | Gift of Mary J. Kingsland, 1906 | Made in 1 | New York 3 | United States 3 | Furniture 4 | http://www.metmuseum.org/art/collection/search/8162 | 4/23/2018 8:00:01 AM | Metropolitan Museum of Art, New York, NY 1 | ||||||||||||||||
7663 | 7663 | 27.57.2 | 0 | 1 | 8163 | American Decorative Arts 1 | Tall clock 886 | Tall clock | American 1 | Maker|Maker 6 | Case by|Movement by | John Townsend|William Tomlinson | 1732–1809|active 1733 | Townsend, John|Tomlinson, William 1081 | American|British 28 | 1732 |1733 | 1809 |1733 | 1789 | 1789 | 1789 | Mahogany, cherry, chestnut, oak 1262 | 98 1/4 x 22 x 11 1/8 in. (249.6 x 55.9 x 28.3 cm) | Rogers Fund, 1927 | Made in 1 | Newport 81 | United States 3 | Furniture 4 | http://www.metmuseum.org/art/collection/search/8163 | 4/23/2018 8:00:01 AM | Metropolitan Museum of Art, New York, NY 1 | ||||||||||||||
7664 | 7664 | 1985.341 | 0 | 1 | 8164 | American Decorative Arts 1 | Tall clock 886 | Tall Clock | American 1 | Maker 1 | Joseph Ward | active ca. 1740–60 | Ward, Joseph 1082 | 1737 | 1760 | 1730–40 | 1730 | 1740 | Japanned white pine 1263 | 84 3/4 x 20 x 10 in. (215.3 x 50.8 x 25.4 cm) | Purchase, Virginia L-S Cowles, Diane L-S Hewat, and Marne L-S Hornblower Gifts, in memory of their sister, Clara Lloyd-Smith Weber, 1986 | Made in 1 | Boston 8 | United States 3 | Furniture 4 | http://www.metmuseum.org/art/collection/search/8164 | 4/23/2018 8:00:01 AM | Metropolitan Museum of Art, New York, NY 1 | ||||||||||||||||
7665 | 7665 | 1976.341 | 0 | 1 | 8165 | American Decorative Arts 1 | Tall clock 886 | Tall Clock | American 1 | Maker|Maker 6 | Simon Willard|Benjamin Willard | 1753–1848|1743–1803 | Willard, Simon|Willard, Benjamin 1083 | 1753 |1743 | 1848 |1803 | 1772 | 1772 | 1772 | Mahogany, cherry, white pine 400 | 95 1/4 x 21 7/8 x 10 3/8 in. (241.9 x 55.6 x 26.4 cm) | Gift of Dr. and Mrs. Brooks H. Marsh, 1976 | Made in 1 | Roxbury 158 | United States 3 | Furniture 4 | http://www.metmuseum.org/art/collection/search/8165 | 4/23/2018 8:00:01 AM | Metropolitan Museum of Art, New York, NY 1 | ||||||||||||||||
7666 | 7666 | 42.76.1 | 0 | 1 | 8166 | American Decorative Arts 1 | Tall clock 886 | Tall Clock | American 1 | Maker|Maker 6 | Works by|Case by | Aaron Willard Jr.|John Doggett | 1783–1864|1780–1857 | Willard, Jr. Aaron|Doggett, John 1084 | 1783 |1780 | 1864 |1857 | ca. 1825 | 1822 | 1825 | Mahogany, maple, white pine 133 | 99 3/4 x 19 7/8 in. (253.4 x 50.5 cm) | Purchase, Joseph Pulitzer Bequest, 1942 | Made in 1 | Boston 8 | United States 3 | Furniture 4 | http://www.metmuseum.org/art/collection/search/8166 | 4/23/2018 8:00:01 AM | Metropolitan Museum of Art, New York, NY 1 | |||||||||||||||
7667 | 7667 | 41.160.369 | 0 | 1 | 8167 | American Decorative Arts 1 | Tall clock 886 | Tall Clock | American 1 | Maker|Maker 6 | John Wood Sr.|John Wood Jr. | active ca. 1734–60|1736–1793 | Wood, Sr. John|Wood, Jr. John 1085 | 1731 |1736 | 1760 |1793 | 1750–60 | 1750 | 1760 | Walnut, tulip poplar, white pine 1264 | 107 1/2 x 23 1/2 x 11 3/8 in. (273.1 x 59.7 x 28.9 cm) | Bequest of W. Gedney Beatty, 1941 | Made in 1 | Philadelphia 1 | United States 3 | Furniture 4 | http://www.metmuseum.org/art/collection/search/8167 | 4/23/2018 8:00:01 AM | Metropolitan Museum of Art, New York, NY 1 | ||||||||||||||||
12311 | 12311 | 1990.175 | 0 | 1 | 13416 | American Decorative Arts 1 | Tall clock 886 | Tall Clock | American 1 | Maker 1 | Peter Stretch | 1670–1746 | Stretch, Peter 1946 | 1670 | 1746 | ca. 1730 | 1727 | 1730 | Walnut, tulip poplar 391 | 97 x 20 7/8 x 11 1/4 in. (246.4 x 53 x 28.6 cm) | Bequest of Gertrude Schweitzer, 1990 | Made in 1 | Philadelphia 1 | United States 3 | Furniture 4 | http://www.metmuseum.org/art/collection/search/13416 | 4/23/2018 8:00:01 AM | Metropolitan Museum of Art, New York, NY 1 | ||||||||||||||||
14886 | 14886 | 1998.126 | 0 | 1 | 16145 | American Decorative Arts 1 | Tall clock 886 | Tall Clock | American 1 | Artist 2 | Gustav Stickley | American, Osceola, Wisconsin 1858–1942 Syracuse, New York | Stickley, Gustav 321 | American 1 | 1858 | 1942 | ca. 1902 | 1902 | 1902 | Oak, brass 2528 | H. 74 in. (188 cm) | Gift of Donald M. Brennan, in memory of Louis Henry Hollister, 1998 | Made in 1 | Eastwood 144 | United States 3 | Furniture 4 | http://www.metmuseum.org/art/collection/search/16145 | 4/23/2018 8:00:01 AM | Metropolitan Museum of Art, New York, NY 1 | |||||||||||||||
15045 | 15045 | 1998.12 | 0 | 1 | 16307 | American Decorative Arts 1 | Tall clock 886 | Tall Clock | American 1 | Maker|Maker|Decorator|Maker 69 | Case attributed to|Works signed|Dial possibly painted by|Possibly with | Thomas Seymour|James Doull|John Ritto Penniman|John Seymour | 1771–1848|American, Milford, Massachusetts 1782–1841 Baltimore, Maryland|active ca. 1794–1816 | Seymour, Thomas|Doull, James|Penniman, John Ritto|Seymour, John 2350 | American 1 | 1771 |1782 |1791 | 1848 |9999 |1841 |1816 | 1805–10 | 1805 | 1810 | Mahogany, mahogany veneer, maple with white pine 2543 | 111 3/4 x 21 1/4 x 9 3/4 in. (283.8 x 54 x 24.8 cm) | Purchase, Anthony W. and Lulu C. Wang Gift, 1998 | Made in 1 | Boston 8 | New England 86 | New England 87 | United States 3 | Furniture 4 | http://www.metmuseum.org/art/collection/search/16307 | 4/23/2018 8:00:01 AM | Metropolitan Museum of Art, New York, NY 1 | ||||||||||||
15302 | 15302 | 1999.48.1 | 0 | 0 | 16570 | American Decorative Arts 1 | Tall clock 886 | Tall Clock | American 1 | Artist 2 | Simon Willard | 1753–1848 | Willard, Simon 502 | 1753 | 1848 | ca. 1800 | 1797 | 1803 | Mahogany, mahogany veneer, white pine 1175 | 95 1/4 x 20 3/8 x 9 1/2 in. (241.9 x 51.8 x 24.1 cm) | Bequest of Marilyn Preston Graves,1999 | Made in 1 | Boston 8 | New England 86 | New England 87 | United States 3 | Furniture 4 | http://www.metmuseum.org/art/collection/search/16570 | 4/23/2018 8:00:01 AM | Metropolitan Museum of Art, New York, NY 1 | ||||||||||||||
15463 | 15463 | 2000.246 | 0 | 0 | 16747 | American Decorative Arts 1 | Tall clock 886 | Tall Clock | American 1 | Artist|Artist 13 | Duncan Beard|C. Weaver | died 1797 | Beard, Duncan|Weaver, C. 2387 | 1797 | 1797 |9999 | 1790 | 1790 | 1790 | Case: mahogany (poplar, pine secondary woods) Clock: painted iron dial; brass works 2644 | 102 x 22 1/4 x 11 3/4 in. (259.1 x 56.5 x 29.8 cm) | Purchase, Sewell C. Biggs Gift, 2000 | Made in 1 | United States 3 | Furniture 4 | http://www.metmuseum.org/art/collection/search/16747 | 4/23/2018 8:00:01 AM | Metropolitan Museum of Art, New York, NY 1 |
JSON shape: default, array, newline-delimited
CREATE TABLE "MetObjects" ( "Object Number" TEXT, "Is Highlight" INTEGER, "Is Public Domain" INTEGER, "Object ID" INTEGER, "Department" INTEGER, "Object Name" INTEGER, "Title" TEXT, "Culture" INTEGER, "Period" REAL, "Dynasty" INTEGER, "Reign" INTEGER, "Portfolio" INTEGER, "Artist Role" INTEGER, "Artist Prefix" REAL, "Artist Display Name" TEXT, "Artist Display Bio" TEXT, "Artist Suffix" REAL, "Artist Alpha Sort" INTEGER, "Artist Nationality" INTEGER, "Artist Begin Date" TEXT, "Artist End Date" TEXT, "Object Date" TEXT, "Object Begin Date" INTEGER, "Object End Date" INTEGER, "Medium" INTEGER, "Dimensions" TEXT, "Credit Line" TEXT, "Geography Type" INTEGER, "City" INTEGER, "State" INTEGER, "County" INTEGER, "Country" INTEGER, "Region" INTEGER, "Subregion" INTEGER, "Locale" INTEGER, "Locus" INTEGER, "Excavation" INTEGER, "River" INTEGER, "Classification" INTEGER, "Rights and Reproduction" REAL, "Link Resource" TEXT, "Metadata Date" TEXT, "Repository" INTEGER , FOREIGN KEY ("Department") REFERENCES [Department](id), FOREIGN KEY ("Object Name") REFERENCES [Object Name](id), FOREIGN KEY ("Culture") REFERENCES [Culture](id), FOREIGN KEY ("Dynasty") REFERENCES [Dynasty](id), FOREIGN KEY ("Reign") REFERENCES [Reign](id), FOREIGN KEY ("Portfolio") REFERENCES [Portfolio](id), FOREIGN KEY ("Artist Role") REFERENCES [Artist Role](id), FOREIGN KEY ("Artist Alpha Sort") REFERENCES [Artist Alpha Sort](id), FOREIGN KEY ("Artist Nationality") REFERENCES [Artist Nationality](id), FOREIGN KEY ("Medium") REFERENCES [Medium](id), FOREIGN KEY ("Geography Type") REFERENCES [Geography Type](id), FOREIGN KEY ("City") REFERENCES [City](id), FOREIGN KEY ("State") REFERENCES [State](id), FOREIGN KEY ("County") REFERENCES [County](id), FOREIGN KEY ("Country") REFERENCES [Country](id), FOREIGN KEY ("Region") REFERENCES [Region](id), FOREIGN KEY ("Subregion") REFERENCES [Subregion](id), FOREIGN KEY ("Locale") REFERENCES [Locale](id), FOREIGN KEY ("Locus") REFERENCES [Locus](id), FOREIGN KEY ("Excavation") REFERENCES [Excavation](id), FOREIGN KEY ("River") REFERENCES [River](id), FOREIGN KEY ("Classification") REFERENCES [Classification](id), FOREIGN KEY ("Repository") REFERENCES [Repository](id)); CREATE INDEX ["MetObjects_Department"] ON [MetObjects]("Department"); CREATE INDEX ["MetObjects_Object Name"] ON [MetObjects]("Object Name"); CREATE INDEX ["MetObjects_Culture"] ON [MetObjects]("Culture"); CREATE INDEX ["MetObjects_Dynasty"] ON [MetObjects]("Dynasty"); CREATE INDEX ["MetObjects_Reign"] ON [MetObjects]("Reign"); CREATE INDEX ["MetObjects_Portfolio"] ON [MetObjects]("Portfolio"); CREATE INDEX ["MetObjects_Artist Role"] ON [MetObjects]("Artist Role"); CREATE INDEX ["MetObjects_Artist Alpha Sort"] ON [MetObjects]("Artist Alpha Sort"); CREATE INDEX ["MetObjects_Artist Nationality"] ON [MetObjects]("Artist Nationality"); CREATE INDEX ["MetObjects_Medium"] ON [MetObjects]("Medium"); CREATE INDEX ["MetObjects_Geography Type"] ON [MetObjects]("Geography Type"); CREATE INDEX ["MetObjects_City"] ON [MetObjects]("City"); CREATE INDEX ["MetObjects_State"] ON [MetObjects]("State"); CREATE INDEX ["MetObjects_County"] ON [MetObjects]("County"); CREATE INDEX ["MetObjects_Country"] ON [MetObjects]("Country"); CREATE INDEX ["MetObjects_Region"] ON [MetObjects]("Region"); CREATE INDEX ["MetObjects_Subregion"] ON [MetObjects]("Subregion"); CREATE INDEX ["MetObjects_Locale"] ON [MetObjects]("Locale"); CREATE INDEX ["MetObjects_Locus"] ON [MetObjects]("Locus"); CREATE INDEX ["MetObjects_Excavation"] ON [MetObjects]("Excavation"); CREATE INDEX ["MetObjects_River"] ON [MetObjects]("River"); CREATE INDEX ["MetObjects_Classification"] ON [MetObjects]("Classification"); CREATE INDEX ["MetObjects_Repository"] ON [MetObjects]("Repository"); CREATE INDEX metobjects_IsHighlight ON MetObjects("Is Highlight"); CREATE INDEX metobjects_IsPublicDomain ON MetObjects("Is Public Domain"); CREATE INDEX metobjects_Department ON MetObjects("Department"); CREATE INDEX metobjects_Culture ON MetObjects("Culture"); CREATE INDEX metobjects_Period ON MetObjects("Period"); CREATE INDEX metobjects_Dynasty ON MetObjects("Dynasty"); CREATE INDEX metobjects_Medium ON MetObjects("Medium"); CREATE INDEX metobjects_City ON MetObjects("City"); CREATE INDEX metobjects_State ON MetObjects("State"); CREATE INDEX metobjects_County ON MetObjects("County"); CREATE INDEX metobjects_Country ON MetObjects("Country"); CREATE INDEX metobjects_Region ON MetObjects("Region"); CREATE INDEX metobjects_Subregion ON MetObjects("Subregion"); CREATE INDEX metobjects_Locale ON MetObjects("Locale"); CREATE INDEX metobjects_Locus ON MetObjects("Locus"); CREATE INDEX metobjects_Excavation ON MetObjects("Excavation"); CREATE INDEX metobjects_River ON MetObjects("River");